Helpful Information

Category: SQL

SQL -> Array

Hey!

Im trying to get some results from a DB cell into an array.

Table name = stores

Cell 1 = Employee Number
Cell 2 = Stores

Cell 2 will contain something like 1 | 2 | 3 | 4 and I want it to output into an array when I search on cell 1..

Any ideas folks?

Andy

If you are wanting to make the value into array of numbers then try this:

<?php

// Assume $result is your mysql_fetch_assoc() array..

$result['cell_2'] = explode('|', $result['cell_2']);

?>